MS OFFICE:

=CONCATENAR(SI(DIA(C1)<10,"0",""),TEXTO(DIA(C1),"@"),"/",SI(MES(C1)<10,"0",""),TEXTO(MES(C1),"@"),"/",TEXTO(AO(C1),"@"))



=CONCATENAR(SI(DIA(C1)<10;"0";"");TEXTO(DIA(C1);"@");"/";SI(MES(C1)<10;"0";"");TEXTO(MES(C1);"@");"/";TEXTO(AO(C1);"@"))

*************************************************************************************************************************

OPEN OFFICE:

=CONCATENAR(SI(DA(C1)<10;"0";"");TEXTO(DA(C1);"@");"/";SI(MES(C1)<10;"0";"");TEXTO(MES(C1);"@");"/";TEXTO(AO(C1);"@"))